home *** CD-ROM | disk | FTP | other *** search
/ Winzipper / Winzipper_ISO.iso / programming / oracle7 7.2 / DB / UTIL72 / CATSTATD.SQL < prev    next >
Encoding:
Text File  |  1995-05-09  |  3.4 KB  |  62 lines
  1. rem 
  2. rem $Header: catstatd.sql 7020100.1 94/09/23 22:14:19 cli Generic<base> $ 
  3. rem 
  4. Rem  Copyright (c) 1991 by Oracle Corporation 
  5. Rem    NAME
  6. Rem      catstatd.sql
  7. Rem    DESCRIPTION
  8. Rem      Delete statistics from all dictionary clusters and tables.
  9. Rem    NOTES
  10. Rem      Must be connected as sys or internal.
  11. Rem    MODIFIED   (MM/DD/YY)
  12. Rem     tpystyne   11/06/92 -  Creation 
  13.  
  14. analyze cluster C_COBJ# delete statistics;                       
  15. analyze cluster C_FILE#_BLOCK# delete statistics;                
  16. analyze cluster C_MLOG# delete statistics;                       
  17. analyze cluster C_OBJ# delete statistics;                        
  18. analyze cluster C_TS# delete statistics;                         
  19. analyze cluster C_USER# delete statistics;                       
  20. analyze cluster HIST$ delete statistics;                         
  21.  
  22. analyze table ACCESS$ delete statistics;                       
  23. analyze table AUD$ delete statistics;                          
  24. analyze table AUDIT$ delete statistics;                        
  25. analyze table BOOTSTRAP$ delete statistics;                    
  26. analyze table COM$ delete statistics;                          
  27. analyze table CON$ delete statistics;                          
  28. analyze table DEFROLE$ delete statistics;                      
  29. analyze table DEPENDENCY$ delete statistics;                   
  30. analyze table DUAL delete statistics;                          
  31. analyze table ERROR$ delete statistics;                        
  32. analyze table FILE$ delete statistics;                         
  33. analyze table IDL_CHAR$ delete statistics;                     
  34. analyze table IDL_SB4$ delete statistics;                      
  35. analyze table IDL_UB1$ delete statistics;                      
  36. analyze table IDL_UB2$ delete statistics;                      
  37. analyze table INCEXP delete statistics;                        
  38. analyze table INCFIL delete statistics;                        
  39. analyze table INCVID delete statistics;                        
  40. analyze table LAB$ delete statistics;                          
  41. analyze table LINK$ delete statistics;                         
  42. analyze table OBJ$ delete statistics;                          
  43. analyze table OBJAUTH$ delete statistics;                      
  44. analyze table PENDING_SESSIONS$ delete statistics;             
  45. analyze table PENDING_SUB_SESSIONS$ delete statistics;         
  46. analyze table PENDING_TRANS$ delete statistics;                
  47. analyze table PROCEDURE$ delete statistics;                    
  48. analyze table PROFILE$ delete statistics;                      
  49. analyze table PROFNAME$ delete statistics;                     
  50. analyze table PROPS$ delete statistics;                        
  51. analyze table RESOURCE_COST$ delete statistics;                
  52. analyze table SEQ$ delete statistics;                          
  53. analyze table SNAP$ delete statistics;                         
  54. analyze table SOURCE$ delete statistics;                       
  55. analyze table SYN$ delete statistics;                          
  56. analyze table SYSAUTH$ delete statistics;                      
  57. analyze table TRIGGER$ delete statistics;                      
  58. analyze table TRIGGERCOL$ delete statistics;                   
  59. analyze table UNDO$ delete statistics;                         
  60. analyze table VIEW$ delete statistics;                         
  61. analyze table "_default_auditing_options_" delete statistics;    
  62.